package com.hospital.demo.mapper.zhangweibo;

import com.hospital.demo.model.zhangweibo.Salarymanage;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface SalarymanageMapper {
    //查询全部信息
    @Select("SELECT * from salarymanage")
    List<Salarymanage> SelectAllSalary();
    //信息的添加
    @Insert("INSERT into salarymanage values(Null,#{salarymanage.sm_did},#{salarymanage.sm_wid},#{salarymanage.smmoney},#{salarymanage.smdate},#{salarymanage.sm_widmanger})")
    Integer InsertSalary(@Param("salarymanage") Salarymanage salarymanage);
}
